﻿CREATE TABLE [dbo].[OrderGeneralReceiptInfo] (
    [OrderReceiptInfoID] UNIQUEIDENTIFIER NOT NULL,
    [ProvID]             INT              NULL,
    [CityID]             INT              NULL,
    [CountyID]           INT              NULL,
    [SpecificAddress]    NVARCHAR (200)   NULL,
    [FullAddress]        NVARCHAR (300)   NOT NULL,
    [Consignee]          NVARCHAR (20)    NOT NULL,
    [Phone]              VARCHAR (50)     NOT NULL,
    [PostalCode]         VARCHAR (10)     NULL,
    [Remark]             NVARCHAR (200)   NULL,
    [UserID]             BIGINT           NOT NULL,
    [DeliveryTime]       TINYINT          NULL,
    [UserReceiptID]      BIGINT           NULL,
    CONSTRAINT [PK_ORDERGENERALRECEIPTINFO] PRIMARY KEY CLUSTERED ([OrderReceiptInfoID] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户收货标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'UserReceiptID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'配送时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'DeliveryTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'UserID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'备注', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'Remark';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'邮政编码', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'PostalCode';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'联系电话', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'Phone';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'收货人', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'Consignee';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'完整地址。省名+市名+县/区名+详细地址', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'FullAddress';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'详细地址。补充地址，街道/路口、村、楼层、楼栋号、门牌号等', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'SpecificAddress';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'县/区标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'CountyID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'市标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'CityID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'省标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'ProvID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'订单收货标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo', @level2type = N'COLUMN', @level2name = N'OrderReceiptInfoID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'订单普通收货信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderGeneralReceiptInfo';

